CREATE TABLE [dbo].[Basket_Dues]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_ID] DEFAULT (''),
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_PRODUCT_CODE] DEFAULT (''),
[BILL_DATE] [datetime] NULL,
[BALANCE] [money] NOT NULL CONSTRAINT [DF_Basket_Dues_BALANCE] DEFAULT ((0)),
[BILL_BEGIN] [datetime] NULL,
[BILL_THRU] [datetime] NULL,
[BILL_COPIES] [int] NULL,
[PAID_THRU] [datetime] NULL,
[STATUS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_STATUS] DEFAULT (''),
[RENEW_MONTHS] [tinyint] NOT NULL CONSTRAINT [DF_Basket_Dues_RENEW_MONTHS] DEFAULT ((0)),
[PRICE_1] [money] NOT NULL CONSTRAINT [DF_Basket_Dues_PRICE_1] DEFAULT ((0)),
[PROD_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_PROD_TYPE] DEFAULT (''),
[TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_TITLE] DEFAULT (''),
[INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_INCOME_ACCOUNT] DEFAULT (''),
[DEFERRED_INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_DEFERRED_INCOME_ACCOUNT] DEFAULT (''),
[PRICE_RULES_EXIST] [bit] NOT NULL CONSTRAINT [DF_Basket_Dues_PRICE_RULES_EXIST] DEFAULT ((0)),
[PAYMENT_PRIORITY] [int] NOT NULL CONSTRAINT [DF_Basket_Dues_PAYMENT_PRIORITY] DEFAULT ((0)),
[CFTOKEN] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_CFTOKEN] DEFAULT (''),
[IP_ADDRESS] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_IP_ADDRESS] DEFAULT (''),
[CFID] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_CFID] DEFAULT (''),
[DESCRIPTION] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_DESCRIPTION] DEFAULT (''),
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_ORG_CODE] DEFAULT (''),
[IS_FR_ITEM] [bit] NOT NULL CONSTRAINT [DF_Basket_Dues_IS_FR_ITEM] DEFAULT ((0)),
[APPEAL_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_APPEAL_CODE] DEFAULT (''),
[CAMPAIGN_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Dues_CAMPAIGN_CODE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
GRANT REFERENCES ON  [dbo].[Basket_Dues] TO [IMIS]
GRANT SELECT ON  [dbo].[Basket_Dues] TO [IMIS]
GRANT INSERT ON  [dbo].[Basket_Dues] TO [IMIS]
GRANT DELETE ON  [dbo].[Basket_Dues] TO [IMIS]
GRANT UPDATE ON  [dbo].[Basket_Dues] TO [IMIS]
GO